package com.atguigu.userprofile.common.dao;

import com.atguigu.userprofile.common.bean.TaskTagRule;
import com.atguigu.userprofile.common.util.MySQLUtil;

import java.util.List;

public class TaskTagRuleDAO {

    public static List<TaskTagRule> getTaskTagRuleList(String taskId){
        String sql=" select tr.* , ti.tag_name as sub_tag_value from task_tag_rule  tr join tag_info ti on  tr.sub_tag_id=ti.id  where task_id='"+taskId+"' ";
        List<TaskTagRule> taskTagRuleList = MySQLUtil.queryList(sql, TaskTagRule.class, true);
        return taskTagRuleList;
    }
}
